Entity Relationships - Diary (VISITS)

Related Tables

Table Name	Table Description	Primary Keys	Usually Joins From	Join Type	Joins On	Details
VISITS	Diary / Visits	VISID				Stores details of each visit in the diaries for trainees, assessors and employers.
TRVISIT	Trainee-Visits Link	TRAINEEID, VISID	VISITS	One to many	VISID	Links trainees to visits. Note that it is possible for multiple trainees to be associated with the same visit.
ASSESSOR	Assessor details	ASSESSORID	VISITS	One to one	ASSESSORID	Stores basic details about each assessor. Assessors can be directly associated with visits.
EMPLOYER	Employer details	EMPLOYERID	VISITS	One to one	EMPLOYERID	Stores basic details about each employer. Employers can be directly associated with visits.
VISITSFILES	Visit Files	FILEID	VISITS	One to one	FILEID	Lists files associated with each visit.